
		
		* Table A18
		* Mechanism Analysis

		clear all
		set more off
	
		use "C:\Users\EAsker\Desktop\ABR\data\ABR_final_data"
		
		drop if qrdinc80_b==2|qrdinc80_b==3
		
		****Baseline controls
		replace fam_inc=. if fam_inc==99|fam_inc==97|fam_inc==0
		gen ln_fam_inc=log(fam_inc)
		
		gen miss_mot_hs=1 if mot_hs==.
		replace miss_mot_hs=0 if mot_hs~=.
		replace mot_hs=0 if mot_hs==.
	

		gen miss_fat_hs=1 if fat_hs==.
		replace miss_fat_hs=0 if fat_hs~=.
		replace fat_hs=0 if fat_hs==.
	   
		gen miss_fam_inc=1 if ln_fam_inc==.
		replace miss_fam_inc=0 if ln_fam_inc~=.
		replace ln_fam_inc=0 if ln_fam_inc==.
	
		gen miss_female=1 if female==.
		replace miss_female=0 if female~=.
		replace female=0 if female==.
	    sort  survey wave sch_id
		
		gen miss_not_white=1 if not_white==.
		replace miss_not_white=0 if not_white~=.
		replace not_white=0 if not_white==.
		
		egen m_weight=mean(weight), by(survey wave sch_id) 
	    replace weight=m_weight if (weight==.|weight==0)&m_weight~=0	
		
		gen log_income=log(income)
		
		gen income_0=income
		replace income_0=. if income_0==0
		
		egen ed_att_hs=mean(high_school), by(fipst year qrdinc80_b)
		egen ed_att_col=mean(post_scndry), by(fipst year qrdinc80_b)
		
***************************************************************************		
***************************************************************************

		local controls_civic "miss_mot_hs miss_fat_hs miss_fam_inc miss_not_white miss_female mot_hs fat_hs ln_fam_inc not_white female"
		
		foreach y of varlist vltnry_prtcptn vlntry_hours register_vote  {
	   	
		************** BHJ
		reghdfe `y' qr1_sfr_exp_trend_BHJ  qr1_sfr_BHJ  ed_att_hs ed_att_col ///
		`controls_civic' if wave==2, absorb ( statexsurvey_quartile ///
		quartilexstate quartilexsurvey) cluster (quartilexstate) 
		
		outreg2 using "C:\Civic\ABR\output_2_15_24\Table_A18.xls", ///
		append ctitle(`y') sdec(4) bdec(4) nonotes nocons ///
		keep(qr1_sfr_exp_trend_BHJ  qr1_sfr_BHJ ed_att_hs ed_att_col) ///
		addtext(Control, YES, State by Survey FE, YES, Quartile by State FE, ///
		YES, Quartile by Survey FE, YES) 
				 
}
